org.nuxeo.retention.pageprovider.contrib dc:title ILIKE '?%' AND ecm:mixinType = 'RetentionRule' AND retention_rule:enabled = 1 AND ecm:isTrashed = 0 50 SELECT * FROM Document WHERE ecm:mixinType = 'RetentionRule' AND retention_rule:enabled = 1 AND ecm:isTrashed = 0 50 RetentionSearch file:content/name IS NOT NULL AND ecm:isVersion = 0 AND ecm:mixinType != 'HiddenInNavigation' 10 10 "dd-MM-yyyy" "dd-MM-yyyy" record:ruleIds/* IS NULL ecm:retainUntil IS NULL record:ruleIds/* IS NOT NULL ecm:retainUntil IS NOT NULL ecm:hasLegalHold = 1 ecm:hasLegalHold = 0 ecm:isTrashed = 0 20